USE [MyCarat]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
if exists(select * from sysobjects where id=object_id('sp_AddAnswer') )
        drop proc sp_AddAnswer
GO
create proc [dbo].[sp_AddAnswer]
  
   @ID varchar(35),
   @questionID varchar(35),
   @answerContent varchar(250),
   @answerTime datetime
   
   as 
   
   begin tran
   
   insert into answer(ID, questionID,answerContent,answerTime)
   values(@ID, @questionID, @answerContent, @answerTime)
                                
                            
 commit tran 